/*
 Navicat Premium Data Transfer

 Source Server         : 沃牛工作室-本地测试
 Source Server Type    : MySQL
 Source Server Version : 50626
 Source Host           : localhost:3306
 Source Schema         : localdb_lavb_v24_0613

 Target Server Type    : MySQL
 Target Server Version : 50626
 File Encoding         : 65001

 Date: 02/09/2024 10:31:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bage_bill
-- ----------------------------
DROP TABLE IF EXISTS `bage_bill`;
CREATE TABLE `bage_bill` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(2) DEFAULT NULL,
  `op_eat` int(2) DEFAULT NULL,
  `op_traffic` int(2) DEFAULT NULL,
  `op_other` int(2) DEFAULT NULL,
  `op_other_notes` varchar(200) DEFAULT NULL,
  `total` int(2) DEFAULT NULL,
  `addtime` date DEFAULT NULL,
  `op_today_profit` varchar(5) DEFAULT NULL COMMENT '每日理财收益',
  `op_today_reading` varchar(5) DEFAULT NULL COMMENT '每日读书时长/分钟',
  `op_today_running` varchar(5) DEFAULT NULL COMMENT '每日跑步里程/公里',
  `every_month_wages` varchar(5) DEFAULT NULL COMMENT '工资收入',
  `op_today_profit_notes` varchar(200) DEFAULT NULL COMMENT '每日收益备注（理财或其他业务）',
  `add_month` varchar(255) DEFAULT NULL COMMENT '添加月份，格式为2020-12。',
  PRIMARY KEY (`id`),
  KEY `addtime` (`addtime`)
) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bage_bill
-- ----------------------------
BEGIN;
INSERT INTO `bage_bill` VALUES (1, 101, 28, 12, 6, '下午茶5.5', 45, '2021-02-01', '0', '0', NULL, '', NULL, '2021-01');
INSERT INTO `bage_bill` VALUES (2, 101, 25, 12, 12, '早咖啡12', 49, '2021-02-02', '0', '0', NULL, '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (3, 101, 26, 26, 13, '下午茶（咖啡13）', 65, '2021-02-03', '0', '0', NULL, '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (4, 101, 25, 26, 9, '', 59, '2021-02-04', '0', '0', NULL, '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (5, 101, 24, 24, 44, '咖啡14，停车费30', 92, '2021-02-05', '0.02', '0.02', NULL, '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (6, 101, 0, 6, 720, '换了轮胎600，超市购买菜等88，手机壳25，咖啡13', 726, '2021-02-06', '0.01', '0.01', NULL, '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (7, 101, 21, 24, 63, '与170西溪喝粥40，超市11，停车费12', 108, '2021-02-07', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (8, 101, 20, 24, 24, '20停车费，下午茶3.5', 67, '2021-02-08', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (9, 101, 23, 24, 2923, '换花呗2923', 2970, '2021-02-09', '0', '0', '0', '12000', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (10, 101, 22, 24, 4098, '还成斌4000,超市购买年货98', 4144, '2021-02-10', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (11, 101, 0, 0, 500, '给外甥包红包500', 500, '2021-02-11', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (12, 101, 0, 0, 31, '美团卖水果31', 31, '2021-02-13', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (13, 101, 0, 0, 95, '超市买些生活必备品', 94, '2021-02-14', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (14, 101, 0, 0, 14, '奶茶14', 14, '2021-02-17', '0', '0', '0', '0', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (15, 101, 0, 0, 200, '带周艳去富阳玩交通90，超市买盐鱼等100', 200, '2021-02-16', '0', '0', '0', '0', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (16, 101, 22, 24, 19, '上香8.8，下午茶10.5', 65, '2021-02-18', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (17, 101, 25, 24, 11, '咖啡11.2', 59, '2021-02-19', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (18, 101, 0, 0, 111, '咖啡11，电费100', 111, '2021-02-21', '0', '0', '0.94', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (19, 101, 23, 13, 577, '下午茶13，按摩服务398，滨江回下沙打车154.66，夜宵鸡排10', 612, '2021-02-22', '0', '0', '0', '', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (20, 101, 22, 24, 23, '下午茶11，其他22', 69, '2021-03-03', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (21, 101, 0, 24, 158, '话费100，停车费40，下午茶18', 182, '2021-02-23', '1', '1', '1', '1', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (22, 101, 27, 24, 161, '话费100，早餐6。5', 210, '2021-02-25', '1', '1', '1', '1', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (23, 101, 27, 10, 18, '下午茶11，早餐7', 54, '2021-02-26', '1', '1', '1', '1', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (24, 101, 15, 1, 362, '抱枕50，交通罚款300，钓鱼耳11.5', 377, '2021-02-27', '58', '1', '1', '1', NULL, '2021-02');
INSERT INTO `bage_bill` VALUES (25, 101, 1, 24, 50, '烟20，停车费30', 75, '2021-03-01', '0', '1', '1', '1', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (26, 101, 0, 24, 45, '下午茶15，停车费30', 69, '2021-03-04', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (27, 101, 0, 12, 16, '下午茶16', 28, '2021-03-05', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (28, 101, 0, 24, 32, '两包烟20，早餐12', 56, '2021-03-06', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (29, 101, 18, 0, 138, '车牌138', 156, '2021-03-07', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (30, 101, 31, 14, 28, '便利店，咖啡等', 73, '2021-03-08', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (31, 101, 0, 14, 26, '便利店，咖啡等23', 40, '2021-03-09', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (32, 101, 23, 14, 34, '便利店5.6，水果28.8', 71, '2021-03-10', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (33, 101, 5, 14, 15, '咖啡13,便利店1.5', 32, '2021-03-11', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (34, 101, 5, 60, 26, '咖啡13,便利店13，交通费60（错过地铁）', 90, '2021-03-12', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (35, 101, 0, 0, 34, '咖啡13,家里农夫山泉21', 34, '2021-03-13', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (36, 101, 0, 0, 0, '', 0, '2021-03-14', '0', '0', '0', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (37, 101, 0, 14, 121, '咖啡15，茶鸡蛋1.5，酸奶4，交通卡100', 135, '2021-03-15', '0', '0', '1.43', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (38, 101, 54, 0, 180, '180出差上海住酒店', 234, '2021-03-23', '0', '0', '3', '', NULL, '2021-03');
INSERT INTO `bage_bill` VALUES (39, 101, 0, 24, 58, '停车费50，下午茶8', 82, '2021-03-25', '37', '0', '0', '', '滴答顺风车37', '2021-03');
INSERT INTO `bage_bill` VALUES (40, 101, 1, 1, 20, '滴滴打车20', 22, '2021-04-01', '0', '0', '0', '0', '0', '2021-04');
INSERT INTO `bage_bill` VALUES (41, 101, 0, 0, 4, '上海地铁4', 4, '2021-04-02', '0', '0', '0', '0', '0', '2021-04');
INSERT INTO `bage_bill` VALUES (42, 101, 0, 0, 165, '回老家，加油165', 165, '2021-04-03', '30000', '0', '0', '0', '为了缓解5w债务，害怕信用逾期，临时家里帮忙了3w。', '2021-04');
INSERT INTO `bage_bill` VALUES (43, 101, 1, 1, 1098, '清明假期返回杭州，油钱350，过路费350，回杭州AMO398', 1100, '2021-04-06', '0', '0', '0', '0', '', '2021-04');
INSERT INTO `bage_bill` VALUES (44, 101, 13, 4, 0, '上海出差，管午饭，主要支出为地铁', 17, '2021-04-09', '0', '0', '0', '0', '', '2021-04');
INSERT INTO `bage_bill` VALUES (45, 101, 43, 10, 21, '咖啡21', 74, '2021-04-16', '0', '0', '0', '14349', '工资收入', '2021-04');
INSERT INTO `bage_bill` VALUES (46, 101, 15, 6, 258, '请吴瑶阳和王宝辰吃饭258。', 279, '2021-04-15', '0', '0', '0', '', '工资收入', '2021-04');
INSERT INTO `bage_bill` VALUES (47, 101, 13, 6, 0, '', 19, '2021-04-14', '0', '0', '0', '', '工资收入', '2021-04');
INSERT INTO `bage_bill` VALUES (48, 101, 6, 9, 25, '奶茶16，水果9', 39, '2021-04-13', '0', '0', '0', '', '工资收入', '2021-04');
INSERT INTO `bage_bill` VALUES (49, 101, 15, 13, 3401, '还花呗3401', 3428, '2021-04-12', '0', '0', '0', '', '工资收入', '2021-04');
INSERT INTO `bage_bill` VALUES (50, 101, 1, 1, 1, '0', 3, '2021-04-23', '0', '1', '1', '1', '1', '2021-04');
INSERT INTO `bage_bill` VALUES (51, 101, 1, 20, 79, '给周发红包52，下午茶15，下午肯德基12', 100, '2021-05-29', '0.1', '0.1', '0.1', '0.1', '0.1', '2021-05');
INSERT INTO `bage_bill` VALUES (52, 101, 16, 50, 417, '下午茶4，咖啡15，398', 483, '2021-06-01', '44', '0', '0.88', '', '顺风车', '2021-06');
INSERT INTO `bage_bill` VALUES (53, 101, 39, 20, 370, '290眼睛框，手表更换卡扣80', 429, '2021-06-02', '46.8', '0', '5', '', '顺风车', '2021-06');
INSERT INTO `bage_bill` VALUES (54, 101, 24, 20, 13, '咖啡13', 57, '2021-06-07', '35.5', '0', '0.57', '', '顺风车', '2021-06');
INSERT INTO `bage_bill` VALUES (67, 110, 0, 20, 28, '咖啡15，便利店11.5，充电宝1.5', 48, '2021-06-09', '0', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (68, 110, 20, 14, 32, '便利店10.8，停车费5，咖啡16', 66, '2021-06-10', '73.3', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (69, 110, 45, 14, 82, '宝龙上网36，电动车更换后视镜25，便利店3.5，咖啡17', 141, '2021-06-11', '0', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (70, 110, 25, 0, 39, '小区停车费15，停车费24', 64, '2021-06-12', '0', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (71, 110, 0, 0, 0, '0', 0, '2021-06-13', '0', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (72, 110, 0, 20, 2081, '货拉拉81，宜家沙发2000', 2101, '2021-06-14', '0', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (73, 110, 27, 20, 87, '便利店21.5，货拉拉搬运费50，咖啡15', 134, '2021-06-15', '0', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (74, 110, 38, 20, 37, '停车费15，咖啡16，便利店6，', 95, '2021-06-16', '42', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (75, 110, 16, 20, 22, '停车费5，咖啡17', 58, '2021-06-17', '42', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (76, 110, 47, 20, 1827, '下午茶11，咖啡16，油卡充值600，加油200，谭战转1000', 1894, '2021-06-18', '52', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (77, 110, 0, 20, 190, '小区停车费5，咖啡16，桶装水82，停车费6，浙大科技园停车费30，久久丫51，便利店10', 210, '2021-06-19', '54', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (78, 110, 0, 0, 106, '卤米松52，一点点13，买菜18，水果18，停车费5', 106, '2021-06-20', '0', '顺风车', '0', '0', '0', '2021-06');
INSERT INTO `bage_bill` VALUES (79, 101, 2, 2, 2, '2', 6, '2024-06-13', '2', '2', '2', '', 'é¡ºé£Žè½¦', '2024-06');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
